OpenEdge Data Management:<br />SQL Reference ASIN

Release 10.1A: OpenEdge Data Management:
SQL Reference

ASIN

Returns the arcsine of expression.

Syntax
ASIN ( expression ) 
Example

In the following example, which shows how to use the ASIN function, the first SELECT statement returns the arcsine in degrees, and the second returns the arcsine in radians:
SELECT ASIN (1) * (180/ pi()) 'Arcsine in degrees' FROM 
SYSPROGRESS.SYSCALCTABLE; 
  
ARCSINE IN DEGREES 
-------------------  
90.000000000000000 
  
1 record selected 
  
  
SELECT ASIN (1) 'Arcsine in radians' FROM SYSPROGRESS.SYSCALCTABLE; 
  
ARCSINE IN RADIANS 
------------------  
1.570796326794897 
  
1 record selected 
ASIN takes the ratio (expression) of two sides of a right triangle and returns the corresponding angle. The ratio is the length of the side opposite the angle divided by the length of the hypotenuse.

The result is expressed in radians and is in the range -pi/2 to pi/2 radians. To convert degrees to radians, multiply degrees by pi/180. To convert radians to degrees, multiply radians by 180/pi.

Notes

The expression must be in the range -1 to 1.

The expression must evaluate to an approximate numeric data type.

Compatibility

ODBC compatible